//package me.zhengjie.minbearwcs.serivce.mission.storageProcessor.booking.Floor5Or6;
//
//import me.zhengjie.minbearwcs.entity.DTO.inboundOld.mission.InboundMissionPoint;
//import me.zhengjie.minbearwcs.entity.DTO.transfer.Tuple;
//
//public interface Storage5Or6FloorBookingSelector {
//
//    /**
//     *
//     * select a.medium_storage_code from medium_storage a
//     * left join
//     * (
//     * select medium_storage_code, count(*) as pallet_num  from small_storage
//     * where pallet_code is  null and inbound_freeze_pallet is  null
//     * and outbound_freeze_pallet is  null
//     * ) b
//     * on a.medium_storage_code = b.medium_storage_code
//     * where
//     * ((material_1 = '' and inbound_order_1 = '' and batch_1 = '')
//     * or (material_2 = '' and inbound_order_2 = '' and batch_2 = ''))
//     * and
//     * pallet_num > 0
//     *
//     * @param materialCode
////     * @param batchCode
//     * @param palletCode
//     * @return
//     */
//
//    Tuple<InboundMissionPoint> searchAndBooking(String materialCode, String batchCode,String palletCode);
//}
